import pandas as pd

df=pd.read_excel('dataset.xlsx',sheet_name='Ligands')
print(df.describe())
print(df['Formula'].value_counts())
print(df['Formula'].value_counts(normalize=True))

print(pd.cut(range(10),bins=5,right=True))
print(pd.cut(range(10),bins=[0,2,4,6,8,10],right=True))
print(pd.cut(range(10),bins=5,right=False))
